﻿CREATE TABLE [dbo].[Store_ProductMainProperty] (
    [Id]               INT             IDENTITY (1, 1) NOT NULL,
    [Name]             NVARCHAR (256)  NOT NULL,
    [BriefDescription] NVARCHAR (4000) NOT NULL,
    [Description]      TEXT            NOT NULL,
    [Cost]             FLOAT (53)      NOT NULL,
    [Store_Product_Id] INT             NOT NULL,
    [Culture_Id]       INT             NOT NULL,
    CONSTRAINT [FK_Store_ProductMainProperties_Store_Product] FOREIGN KEY ([Store_Product_Id]) REFERENCES [dbo].[Store_Product] ([Id]) ON DELETE CASCADE ON UPDATE CASCADE,
    CONSTRAINT [FK_Store_ProductMainPropertys_Cultures] FOREIGN KEY ([Culture_Id]) REFERENCES [dbo].[Cultures] ([Id])
);

